/*
 Navicat Premium Data Transfer

 Source Server         : aliyun
 Source Server Type    : MySQL
 Source Server Version : 50725
 Source Host           : localhost:3306
 Source Schema         : donald_game

 Target Server Type    : MySQL
 Target Server Version : 50725
 File Encoding         : 65001

 Date: 08/03/2021 20:21:59
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for feature
-- ----------------------------
DROP TABLE IF EXISTS `feature`;
CREATE TABLE `feature` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `feature_name` varchar(64) DEFAULT NULL COMMENT '特征名称',
  `description` varchar(255) DEFAULT NULL COMMENT '特征描述',
  `icon` varchar(255) DEFAULT NULL COMMENT '图标',
  `created_by` bigint(20) DEFAULT NULL COMMENT '创建者id',
  `modified_by` bigint(20) DEFAULT NULL COMMENT '修改者id',
  `gmt_created` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT NULL COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标志(默认0:未删除,1:已删除)',
  `version` bigint(60) NOT NULL DEFAULT '0' COMMENT '乐观锁版本',
  `creator` varchar(64) DEFAULT NULL COMMENT '创建者',
  `modifier` varchar(64) DEFAULT NULL COMMENT '更新者',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of feature
-- ----------------------------
BEGIN;
INSERT INTO `feature` VALUES (1, '科幻', NULL, NULL, 6, 6, '2020-12-15 14:39:37', '2020-12-15 14:39:40', 0, 0, 'root', 'root');
INSERT INTO `feature` VALUES (2, '仙侠', NULL, NULL, 6, 6, '2020-12-15 14:39:42', '2020-12-15 14:39:44', 0, 0, 'root', 'root');
INSERT INTO `feature` VALUES (3, '卡通', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for game
-- ----------------------------
DROP TABLE IF EXISTS `game`;
CREATE TABLE `game` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `game_name` varchar(64) DEFAULT NULL COMMENT '游戏名称',
  `picture` varchar(255) DEFAULT NULL COMMENT '图片',
  `type_id` bigint(20) DEFAULT NULL COMMENT '类型id',
  `game_title` varchar(64) DEFAULT NULL COMMENT '游戏标题',
  `platform` tinyint(1) DEFAULT NULL COMMENT '平台0:端游;1:手游',
  `online` tinyint(1) DEFAULT NULL COMMENT '是否在线默认0:单机; 1:网游',
  `company` varchar(64) DEFAULT NULL COMMENT '游戏公司',
  `description` varchar(255) DEFAULT NULL COMMENT '游戏描述',
  `update_date` datetime DEFAULT NULL COMMENT '更新日期',
  `created_by` bigint(20) DEFAULT NULL COMMENT '创建者id',
  `modified_by` bigint(20) DEFAULT NULL COMMENT '修改者id',
  `gmt_created` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT NULL COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标志(默认0:未删除,1:已删除)',
  `version` bigint(60) NOT NULL DEFAULT '0' COMMENT '乐观锁版本',
  `creator` varchar(64) DEFAULT NULL COMMENT '创建者',
  `modifier` varchar(64) DEFAULT NULL COMMENT '更新者',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of game
-- ----------------------------
BEGIN;
INSERT INTO `game` VALUES (1, '测试游戏1', NULL, 1, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL);
INSERT INTO `game` VALUES (2, '跑跑卡丁车', NULL, 2, NULL, 0, 1, '世纪天盛', '垃圾游戏', '2018-01-01 06:00:00', 6, 6, '2020-12-15 17:40:05', '2020-12-15 17:40:05', 0, 0, 'root', 'root');
INSERT INTO `game` VALUES (3, '跑跑卡丁车', NULL, 2, NULL, 0, 1, '世纪天盛', '垃圾游戏', '2018-01-01 06:00:00', 6, 6, '2020-12-15 17:40:05', '2020-12-15 17:40:05', 0, 0, 'root', 'root');
COMMIT;

-- ----------------------------
-- Table structure for game_feature
-- ----------------------------
DROP TABLE IF EXISTS `game_feature`;
CREATE TABLE `game_feature` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `game_id` bigint(20) DEFAULT NULL COMMENT '游戏id',
  `feature_id` bigint(20) DEFAULT NULL COMMENT '特征id',
  `created_by` bigint(20) DEFAULT NULL COMMENT '创建者id',
  `modified_by` bigint(20) DEFAULT NULL COMMENT '修改者id',
  `gmt_created` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT NULL COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标志(默认0:未删除,1:已删除)',
  `version` bigint(60) NOT NULL DEFAULT '0' COMMENT '乐观锁版本',
  `creator` varchar(64) DEFAULT NULL COMMENT '创建者',
  `modifier` varchar(64) DEFAULT NULL COMMENT '更新者',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of game_feature
-- ----------------------------
BEGIN;
INSERT INTO `game_feature` VALUES (1, 1, 2, 6, 6, '2020-12-15 14:40:10', '2020-12-15 14:40:12', 0, 0, 'root', 'root');
INSERT INTO `game_feature` VALUES (2, 2, 3, 6, 6, '2020-12-15 17:40:05', '2020-12-15 17:40:05', 0, 0, 'root', 'root');
INSERT INTO `game_feature` VALUES (3, 3, 3, 6, 6, '2020-12-15 17:40:05', '2020-12-15 17:40:05', 0, 0, 'root', 'root');
COMMIT;

-- ----------------------------
-- Table structure for t_base
-- ----------------------------
DROP TABLE IF EXISTS `t_base`;
CREATE TABLE `t_base` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `created_by` bigint(20) DEFAULT NULL COMMENT '创建者id',
  `modified_by` bigint(20) DEFAULT NULL COMMENT '修改者id',
  `gmt_created` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT NULL COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标志(默认0:未删除,1:已删除)',
  `version` bigint(60) NOT NULL DEFAULT '0' COMMENT '乐观锁版本',
  `creator` varchar(64) DEFAULT NULL COMMENT '创建者',
  `modifier` varchar(64) DEFAULT NULL COMMENT '更新者',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of t_base
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for type
-- ----------------------------
DROP TABLE IF EXISTS `type`;
CREATE TABLE `type` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `type_name` varchar(64) DEFAULT NULL COMMENT '类型名称',
  `icon` varchar(255) DEFAULT NULL COMMENT '图标',
  `description` varchar(64) DEFAULT NULL COMMENT '类型描述',
  `created_by` bigint(20) DEFAULT NULL COMMENT '创建者id',
  `modified_by` bigint(20) DEFAULT NULL COMMENT '修改者id',
  `gmt_created` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT NULL COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标志(默认0:未删除,1:已删除)',
  `version` bigint(60) NOT NULL DEFAULT '0' COMMENT '乐观锁版本',
  `creator` varchar(64) DEFAULT NULL COMMENT '创建者',
  `modifier` varchar(64) DEFAULT NULL COMMENT '更新者',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of type
-- ----------------------------
BEGIN;
INSERT INTO `type` VALUES (1, '益智', NULL, NULL, 6, 6, '2020-12-15 14:40:38', '2020-12-15 14:40:35', 0, 0, 'root', 'root');
INSERT INTO `type` VALUES (2, '竞速', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL);
INSERT INTO `type` VALUES (3, '动作', NULL, NULL, 6, 6, '2020-12-16 23:16:13', '2020-12-16 23:16:13', 0, 0, 'root', 'root');
INSERT INTO `type` VALUES (4, '动作', NULL, NULL, 6, 6, '2020-12-17 17:50:55', '2020-12-17 17:50:55', 0, 0, 'root', 'root');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
